﻿namespace zyn_hy_login
{
    using System;
    using System.Data;

    public class Get_Hy_Num
    {
        public string Get_Num(string hy_name, string hy_email)
        {
            DataRow row = DBCommon.getDataBySql("select top 1 Hy_Id,Hy_login_Name,Hy_Email from hy_login_info where Hy_login_Name='" + hy_name + "' and Hy_Email='" + hy_email + "'").Tables[0].Rows[0];
            string s = "";
            if (!row.IsNull(0))
            {
                s = row["Hy_Id"].ToString();
            }
            string text3 = "86" + int.Parse(s).ToString();
            DBCommon.excuteSql("update hy_login_info set Hy_Num='" + text3 + "' where Hy_Id=" + s);
            return text3;
        }
    }
}

